﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;

using DbAccessLib;

namespace DataAccess
{
    public class DuongDAO
    {
        static private DuongDAO m_DAO = new DuongDAO();

        static public DuongDAO DAO
        {
            get { return m_DAO; }
        }

        private DuongDAO()
        {
        }

        public DataTable layDanhSachCacConDuong()
        {
            String CommandText = " SELECT d.MaDuong , d.TenDuong FROM DUONG d ";
            String CommandText_Exsits = " WHERE (d.MaDuong < 696 and d.MaDuong > 681) or (d.MaDuong > 233 and d.MaDuong < 279) ORDER BY d.TenDuong; ";

            SQLStatement cmd = Db.DiaDiemDB.CreateStatement(CommandText + CommandText_Exsits);

            return cmd.ExecuteQuery();
        }
    }
}
